#include /home/hobbydomru/www/inc/dbiconnect.inc
#include /home/hobbydomru/www/inc/sub.ephtml
#include /home/hobbydomru/www/inc/head2.inc
use CGI;
$CGI_PARAMS=new CGI;
my $class="";
$input{'tur'}=$CGI_PARAMS->param('tur');
$query="SELECT id_turnir, name FROM tur WHERE id=$input{'tur'}";
$res=$DB->prepare($query) or die "Can't prepare query: $query\n";
$res->execute or die "Can't execute query: $query\n";
$res=$res->fetchrow_hashref();
$input{'turnir'}=$res->{id_turnir};
$name_tur=$res->{name};
%equips=&equips($input{'turnir'});
$query="SELECT name FROM turnir WHERE id=$input{'turnir'}";
$res=$DB->prepare($query) or die "Can't prepare query: $query\n";
$res->execute or die "Can't execute query: $query\n";
$res=$res->fetchrow_hashref();
$name_turnir=$res->{name};
$query="SELECT id_match, gol1, gol2 FROM prognoz WHERE id_player=".$DB->quote($ENV{REMOTE_USER});
$result=$DB->prepare($query) or die "Can't prepare query: $query\n";
$result->execute or die "Can't execute query: $query\n";
while (my $hashref = $result->fetchrow_hashref) {
$voted{$hashref->{id_match}}->{gol1}=$hashref->{gol1};
$voted{$hashref->{id_match}}->{gol2}=$hashref->{gol2};
}
#$query="SELECT * FROM igra, tur WHERE igra.id_tur=$input{'tur'} AND tur.id_turnir=$input{'turnir'} GROUP BY igra.id";
$query=" SELECT * FROM igra LEFT JOIN tur ON igra.id_tur=tur.id WHERE tur.id = $input{'tur'}";
#print $query."
";
$result=$DB->prepare($query) or die "Can't prepare query: $query\n";
$result->execute or die "Can't execute query: $query\n";
!>